Hi,
Is it possible to output of a DXL Script to a spreadsheet??
For Example, consider the case of fetching the data/attribute from other module to the current module. Instead of populating the attribute, is it possible to fetch the output to an excel sheet directly?
In other words, is file handling possible with DXL Scripts??
Lion29 - Wed Feb 03 14:31:42 EST 2010 |
|
Re: File Handling with DXL.
kbmurphy - Wed Feb 03 14:57:01 EST 2010
Yes.
|
|
Re: File Handling with DXL.
Lion29 - Wed Feb 03 15:15:34 EST 2010 kbmurphy - Wed Feb 03 14:57:01 EST 2010
Yes.
i'm in need of tat... :-)
|
|
Re: File Handling with DXL.
kbmurphy - Wed Feb 03 19:10:10 EST 2010 Lion29 - Wed Feb 03 15:15:34 EST 2010
Can you plese tell me how to do tat...
i'm in need of tat... :-)
To do a CSV file, look up Streams in the DXL Reference Manual
To write directly to Excel, you can check out OLE Automation in the DXL Reference Manual, look at the built-in example (lib/dxl/standard/export/office/excel.dxl) or go to galactic-solutions.com and study the code in "Enhanced Export to Excel", which is MUCH better than the built-in example.
Good luck.
|
|
Re: File Handling with DXL.
Peter_Albert - Thu Feb 04 03:27:00 EST 2010 kbmurphy - Wed Feb 03 19:10:10 EST 2010
You have two options. Write to a comma separated file, or write directly to Excel.
To do a CSV file, look up Streams in the DXL Reference Manual
To write directly to Excel, you can check out OLE Automation in the DXL Reference Manual, look at the built-in example (lib/dxl/standard/export/office/excel.dxl) or go to galactic-solutions.com and study the code in "Enhanced Export to Excel", which is MUCH better than the built-in example.
Good luck.
https://www.ibm.com/developerworks/wikis/pages/viewpageattachments.action?pageId=93585672
Peter
|
|
Re: File Handling with DXL.
Peter_Albert - Thu Feb 04 03:29:54 EST 2010 Peter_Albert - Thu Feb 04 03:27:00 EST 2010
If you want to go the OLE way, it helps a lot to have the OLE.inc and ExcelFunctions.inc from the https://www.ibm.com/developerworks/wikis/pages/viewpageattachments.action?pageId=93585672
Peter
I would love if the preview and the help pane with the formatting shortcuts would be available always, and not only on random occasion ...
|
|
Re: File Handling with DXL.
llandale - Thu Feb 04 15:02:23 EST 2010 Peter_Albert - Thu Feb 04 03:29:54 EST 2010
Interesting, let's try again: the include files are in the DXL Wiki.
I would love if the preview and the help pane with the formatting shortcuts would be available always, and not only on random occasion ...
|
|